﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="hotelinformation.aspx.vb" Inherits="hotels.hotelinformation" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">



    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataSourceID="SqlDataSource1">
        <Columns>
            <asp:BoundField DataField="HotelName" HeaderText="HotelName" 
                SortExpression="HotelName" />
            <asp:BoundField DataField="Description" HeaderText="Description" 
                SortExpression="Description" />
            <asp:ImageField DataImageUrlField="Picture">
            </asp:ImageField>
        </Columns>
    </asp:GridView>

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:hotelsConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:hotelsConnectionString.ProviderName %>" 
        SelectCommand="SELECT [HotelName], [Description], [Picture] FROM [hotellist] WHERE ([ID] = ?)">
        <SelectParameters>
            <asp:QueryStringParameter DefaultValue="1" Name="ID" QueryStringField="ID" 
                Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>



    <br />
    <br />
    <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
         Width="350px">
        <Columns>
            <asp:BoundField DataField="Author" HeaderText="Author" 
                SortExpression="Author" />
            <asp:BoundField DataField="Comment" HeaderText="Comment" 
                SortExpression="Comment" />
            <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
        ConnectionString="<%$ ConnectionStrings:hotelsConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:hotelsConnectionString.ProviderName %>" 
        SelectCommand="SELECT [Author], [Comment], [Title] FROM [Comments] WHERE ([Hotel_fkId] = ?)">
        <SelectParameters>
            <asp:QueryStringParameter Name="Hotel_fkId" QueryStringField="ID" 
                Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>
    <br />
    <br />
    Add your comment here:<br />
    <br />
    Comment Title:
    <asp:TextBox ID="tb_Title" runat="server" Width="147px"></asp:TextBox>
    <br />
    Your Comment:<br />
&nbsp;<asp:TextBox ID="tb_Comment" runat="server" Height="129px" 
        TextMode="MultiLine" Width="367px"></asp:TextBox>
    <br />
    <asp:Button ID="btn_AddComment" runat="server" Text="Add Your Comment" />
    <br />
    <br />
    ---------------------<br />
    <asp:CheckBoxList ID="CheckBoxList1" runat="server" 
        DataSourceID="tagsDataSource" DataTextField="Tag" DataValueField="ID" 
        RepeatDirection="Horizontal">
    </asp:CheckBoxList>
    Add New Tags Here, separate tags by commas<asp:TextBox ID="TextBox1" runat="server" Width="385px"></asp:TextBox><br />
    <asp:SqlDataSource ID="tagsDataSource" runat="server" 
        ConnectionString="<%$ ConnectionStrings:hotelsConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:hotelsConnectionString.ProviderName %>" 
        SelectCommand="SELECT [ID], [Tag] FROM [Tags] WHERE ([Tag] &lt;&gt; ?)">
        <SelectParameters>
            <asp:Parameter DefaultValue=" " Name="Tag" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:Button ID="Button1" runat="server" Text="Tag This Hotel" Width="113px" />
    <br />



</asp:Content>
